CREATE TABLE [dbo].[TMDOCU_BANC]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TI_DOCU_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NU_DOCU_BANC] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NO_AUXI] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_ENTI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_ENTI] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DE_OBSE] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_ESTA_DOCU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_EXPO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_IMPO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IM_DOCU] [numeric] (16, 4) NULL CONSTRAINT [DF__TMDOCU_BA__IM_DO__4BB72C21] DEFAULT ((0)),
[FA_CAMB_EXTR] [numeric] (15, 6) NULL,
[FA_TIPO_CAMB] [numeric] (15, 6) NULL,
[FE_VALI] [datetime] NULL,
[NU_DIAS_VENC] [int] NULL CONSTRAINT [DF__TMDOCU_BA__NU_DI__4CAB505A] DEFAULT ((0)),
[FE_VENC] [datetime] NULL,
[FE_SOLI] [datetime] NULL,
[NO_BENE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_REFE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_MONE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TMDOCU_BA__CO_US__4D9F7493] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TMDOCU_BA__FE_US__4E9398CC] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TMDOCU_BA__CO_US__4F87BD05] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TMDOCU_BA__FE_US__507BE13E] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMDOCU_BANC] ADD CONSTRAINT [PK__TMDOCU_B__99B930293BABACE1] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_BANC], [TI_DOCU_BANC], [NU_DOCU_BANC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMDOCU_BANC] ADD CONSTRAINT [FK__TMDOCU_BA__CO_EM__77E09279] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
